Using LIKE in Mysql

Asked

Viewed 130 times

-1

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?

mysql

1 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.

  • is that I had not realized that LIKE and WHERE are together and not separated, I had done a LIKE on android but did not use Where together, so I found it strange, then I went to understand, I’m sorry for the stupidity and thank you so much for the help! kkkkkkk

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.