Using LIKE in Mysql

Question

I am trying to run an SQL with LIKE in Mysql without success, with some search I realized that Mysql only accepts like after a Where, but in my search there is no need for Where, because I’m looking into every customer registered at the bank that starts with the letter T.

I’m trying to run SQL this way:

SELECT * FROM PARTNERSHIP LIKE’T%'

Mysql returns the following message:

Unrecognized keyword.

Is there any other way to do this research? if only by LIKE, there is some way to use it without WHERE?

Answer 1

It is not possible. The clause WHERE is the condition that must be obeyed to return records within the established criteria.

Your criterion was set here:

I’m looking to search all registered customers in the bank that start with the letter T.