Function charindex does not exist?

Good night.Trying to extract fields from values shape thansh,sh,gg,123,text only fields where there is 'sh' or the whole word and get the row id,googling found charindex and patindex but the first attempt got an error :/ please Help.Thank you.

code: 'ER_SP_DOES_NOT_EXIST',
errno: 1305,
sqlMessage: 'FUNCTION test.CHARINDEX does not exist',
sqlState: '42000',
index: 0,
sql: "SELECT * FROM tenders WHERE CHARINDEX('sh', category) > 0"


pool.query(`SELECT * FROM tenders WHERE CHARINDEX('sh', category) > 0`, (error,results,fields) => {
 if(error) return console.log(error)
 console.log(results.map(r => r.id))
 })
April 3rd 20 at 17:24
3 answers
April 3rd 20 at 17:26
Solution
Your last response just forgot,I already asked an identical question.Thank you tyk - Mike79 commented on April 3rd 20 at 17:29
April 3rd 20 at 17:28
And it really does not exist.
In maykrosoftovskie DBMS it is, but MySQL is not.

LIKE, not?
Yes, I would zayuzat like,I'm thinking to filter the object and return id if found,like it requires an exact match,but I don't know how many lists of values separated by commas n,n,n,,,,, - Mike79 commented on April 3rd 20 at 17:31
Here for example,to select all rows which have value index number,123 in sql query how to implement it? - Mike79 commented on April 3rd 20 at 17:34
@Mike79, to Usenet AND? - Benedict.Hacke commented on April 3rd 20 at 17:37
@Benedict.Hacke, no)Do silly suggestion, the function find_in_set will help,I forgot about it) - Mike79 commented on April 3rd 20 at 17:40
April 3rd 20 at 17:30
Try to use INSTR(

Find more questions by tags MySQL