Using LIKE in MySql [closed]

-1

I'm trying to run a SQL with LIKE in MySql without success, with some research I realized that MySql only accepts the like after a where, but in my search there is no need of where, since I'm wanting to search all the registered clients in the bank that begin with the letter T.

I'm trying to run SQL like this:

  

SELECT * FROM PARTNERSHIP LIKE 'T%'

MySql returns the following message:

  

Unrecognized keyword.

Do you have any other way to do this research? if it's just LIKE, do you have any way to use it without WHERE?

    
asked by anonymous 11.05.2017 / 21:10

1 answer

1

Not possible. The WHERE clause is the condition that must be obeyed to return records within the established criterion.

Your criteria have been defined here:

  

I want to search all registered customers in the bank that start with the letter T.

    
11.05.2017 / 21:13