Help for this page

Select Code to Download


  1. or download this
     #!/usr/bin/perl -wT

...
$searchstring =~ s/(\w+) ?(OR|NOT|AND)/\(fieldname \= '$1'\) $2/g;

print "SELECT * FROM tablename WHERE $searchstring\n";
  2. or download this
    SELECT * FROM tablename WHERE (fieldname = 'aaaa') OR (fieldname = 'bb
+bb') OR (fieldname = 'cccc') OR dddd
  3. or download this
    SELECT * FROM tablename WHERE (fieldname = 'aaaa') OR (fieldname = 'bb
+bb') OR (fieldname = 'cccc') OR (fieldname =  'dddd')