How to Backup your MySQL Database There are a few approaches to reinforcement MySQL information. In this article we’ll take a gander at how to reinforcement your databases utilizing diverse strategies, we will likewise figure out how to accomplish a… Continue Reading
how to use if else condition in mysql The MySQL IF statement permits you to execute an arrangement of SQL explanations in view of a specific condition or estimation of an expression. To shape an expression in MySQL, you can… Continue Reading
If You have a field arr_val (varchar(50)) in a your table tst_tbl that contains a comma delimited string such as PHP,MySql,Ajax,JQuery,PHP 5.
When running the query select * from arr_val where arr_val like ‘%PHP%’ to get all the only PHP Results ( not PHP 5) , But you will also get the result PHP 5.
Now the Question is “How should we rewrite the query so that is selects ONLY the PHP and not all values containing PHP ? Continue Reading
Suppose You Have a Table promo_code in Your Database Like This: And You want to match code column using MySql. But You only want to match the Value before A Specific Separator (For Ex. ‘BIGOTHA’,’ADSIRO’ in This “promo_code” Table )… Continue Reading