split string in MySQL
-
Hi, I want to know how can I split spilt in MySQL stored procedure. I have this string Jassim Loves Banana I want to split it by space and add x to it so it will be xJassim xLove xBanana
-
Hi, I want to know how can I split spilt in MySQL stored procedure. I have this string Jassim Loves Banana I want to split it by space and add x to it so it will be xJassim xLove xBanana
-
use replace as
SELECT REPLACE('Jassim Loves Banana', ' ', ' x');
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
one more question please.. if I have the string as
jassim rahma
or
jassim ali rahma
or anything else how can split that to be:
<pre>SELECT file_no, old_file_no, account_number, id_number, full_name, date_of_birth FROM patients WHERE MATCH(full_name) AGAINST('jassim' WITH QUERY EXPANSION) and MATCH(full_name) AGAINST('rahma' WITH QUERY EXPANSION) ORDER BY full_name;</pre>