PHP MYSQL search string everyhwere

Is it possible to search a string in table without specifing column?

$string = 'hello';

$sql = mysql_query("SELECT * FROM table WHERE all_columns LIKE '%,$string,%' ");

and i would like to get one response p.e if there would be two columns in one row which containts same or similar content, but this is not important, i can handle it.

// MY IDEA, NOT SO FAST BUT MIGHT WORK

    $sql = mysql_query("SELECT * FROM particular_table LIMIT = 1");
    $data = mysql_fetch_array($sql);

    $limit = count($data);
    $where_condition = 'WHERE published = 1 AND (';

    $index = 1;
    foreach($data as $key=>$val){
          if($index==$limit){
              $where_condition .= ' '.$key.' LIKE %,'.$string.',%'; 
          } else {
              $where_condition .= ' '.$key.' LIKE %,'.$string.',% OR'; 
          }
          $index++;       
    }
    $where_condition .= ')';

    $get = mysql_query("SELECT * FROM particular_table $where_condition"); 
    $res = mysql_fetch_array($get);

It can be stupid and unnecessary so give me your opintion please

Answers


Here's a solution combined with some PHP to search all fields in a specific table.

include("db_con.php");
//search all fields
$searchphrase = "banan";
$table = "apa303";
$sql_search = "select * from ".$table." where ";
$sql_search_fields = Array();
$sql = "SHOW COLUMNS FROM ".$table;
$rs = mysql_query($sql);
    while($r = mysql_fetch_array($rs)){
        $colum = $r[0];
        $sql_search_fields[] = $colum." like('%".$searchphrase."%')";
    }

$sql_search .= implode(" OR ", $sql_search_fields);
$rs2 = mysql_query($sql_search);
$out = mysql_num_rows($rs2)."\n";
echo "Number of search hits in $table " . $out;

Now adjust the query as you want...


Need Your Help

Issue with jQuery UI Dialog when modal is set to TRUE

asp.net webforms jquery-dialog

I'm developing an ASP.NET WebForm application with Visual Studio 2008 SP1 and C#.

PHP Post Data not showing up on local wamp development area?

php apache codeigniter post wamp

I have tried searching for this weird issue, but can't find anything about it. I am also on a deadline of a week, and am going nuts.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.