Similar string search and case insensitive SQL query?

Question

PHP

Hi all.
How to make a case insensitive query in SQL?
for example, there is a line:
TeXt, it is necessary that the line Text or teXT does not matter, find it .. and you can’t do everything in lowercase.
And how to search for a similar string,
for example, there is a MyTexT string in the database, and I'm looking for it by "ytEx", and I need to find exactly this string?
something like this:
WHERE = '%ytex%'
???
Thanks a lot everyone in advance

Answer 1

LIKE , REGEXP , Full-Text Search
And case sensitivity is determined by the specified encoding for the field/table/database.