mysql – Check if a value is contained in the line

Question:

I'm working with a query system, and I would like that, for example: If I search for the value "a", it would return all the rows that have "a". I tried using the like command as shown below:

SELECT * FROM usuario WHERE nome LIKE 'a%';

But it only returns me if the value is at the beginning of the line. How can I check if "a" is contained in the line?

Answer:

The % is a wildcard representing "anything". That is, the search is being done for names that start with "a" and have anything after .

You just need to adapt to anything before and after "a".

SELECT * FROM usuario WHERE nome LIKE '%a%';
Scroll to Top