what is it mean ? select*from table where title like 'IT+_%' escape '+' ;

Answer 1

If you don't use escape return all string like IT123blb ITftyhjjkj etc._ meen any symbols between other two in expressions usually

Answer 2

i think that is a regular expression, basically saying what pattern the row title has to match

Answer 3

This is pattern for string comparison. 'IT' is letters, '+' is screening symbol for '_' and '%' is any number of any characters. So this query will select titles like 'IT_123' or 'IT_abc' or 'IT_1aB##x27; etc.

Answer 4

If we type 'it_%' then '_' symbol will not be screened. Not screened '_' symbol means any one symbol so it will select titles that start with IT, not with IT_

Answer 5

No, + is screening symbol (meaning then next symbol after it should not be a special symbol an means just what it means). And it only when you clarify it with "escape '+'" part. Otherwise defaul screening symbol is '\' so without "escape '+'" you should write '\_' instead of '+_' if you want to screen '_' symbol.

Answer 6

select evry thing in table where title start whit IT_

Answer 7

so what is the different if we type 'it_%' ?

Answer 8

so + help us to put constant values?

Answer 9

thank you very much ❤