▼  Site Navigation Main About Search Articles  ▼  Anime + Manga Anime Reviews Anime Characters Gallery Screenshots Manga Reviews  ▼  Misc News Links to Webcomics Bible Quotes Member Control Panel  ▼  Forum etc. Forums Older Musings Wordpress
site version 7.3
older
newer

11/4/09
Wednesday 1:46am


Date Posted:
11/4/09

ok, there is a problem with the search program.  It is now case sensitive for some reason and it has to do with the new database that I am using.  In short some results might not be displayed when doing a search.  I am trying to figure this out.

UPDATE: I just need to convert it from

SELECT ID, summary FROM memoblog WHERE lcase(concat(ID,summary)) LIKE '%terts%'
to
SELECT ID, summary FROM memoblog WHERE lcase(concat(cast(ID as char),summary)) LIKE '%terts%'

archives


TAGS: none

All Memo Tags
anime 1, commercial 1, computer 5, games 18, hard to remember 1, memo blog 1, moving 2, news 11, none 1554, opera 68, quotes 1, reformat hard drive 19, sgopc 1, site update 5, site version 205, star wars 2, swtor 1, video 1, website 8, wishlist 3

copyright 2005–2019