get data using a lower or upper case using mysql like query? – Phpmyadmin
I want to search for data from the database using MySQL like query here is my query: global $wpdb; if($_GET['search']){ $search = $_GET['search']; } else{ $search = $_GET['searchtop']; } $search_details = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM tbl_brand, tbl_generic, tbl_therapeutic_area, tbl_drug…