| Message Text |
Hi Paul,
I don't know if this is a bug, or something else.
Take a very simple advanced search, with a single field to search in the links for. This is a text field. I enter 'I.' (without single quotation marks), and the system does the below:
`id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`szobaszam`,`felszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`szintek`,`kiadoar`,`helysegenglish`,`epitoanyagenglish`,`erkelyenglish`,`futesenglish`,`kilatasenglish`,`tajolasenglish`,`komfortenglish`,`liftenglish`,`parkolasenglish`,`lakasallapotenglish`,`extrakenglish`,`butorozottenglish`,`descriptionenglish`,`kerulet`,`megye`,`eladokiado`,`gepesitett`,`gepesitettenglish`,`cim`,`hazszam`,`adminnotes`,`telek`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiadoareuro` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1220281754) AND ((kerulet LIKE '% I. %'))) ORDER BY typeorder ASC,time DESC LIMIT 0,60
Load time so far: 0.09 seconds.
Load time so far: 0.09 seconds.
Query 10: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1220281754) AND ((kerulet LIKE '% I. %')))
What is interesting is the LIKE '% I. %'. Why is there a space around my 'I.'? If there wouldn't be, the search would find what I was looking for (I think, I hope).
Thanks
David |
