Mysql regexp or rlike function it same as PHP preg_match() function.
It save the time write code and filter the data.
Mysql regexp or rlike function it same as PHP preg_match() function.
It save the time write code and filter the data.
Using Mysql function add asterisk (*) in front of the string.
Example Output:
********MyTestString
*******MyTestString2
**********TestString
Find the string position. I think most of the Software Engineer will use server side script to do it. I also is the one. For PHP, I will use strpos to get the position.
Generally, we stores various values of choices in 1 column of database. For example, we store user’s preferred categories in user table’s. value stored in this field will be like this 1,2,12,22,4