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%'TAGS: noneAll Memo Tags
allegory 1,
anime 1,
article 6,
audio 2,
books 3,
bug 19,
code 1,
commercial 1,
computer 15,
election 2,
ereader 5,
fixed 11,
games 24,
hard to remember 1,
history 1,
keyboard shortcuts 1,
links 3,
memo blog 1,
mini-review 10,
moving 2,
music 1,
mysql 1,
news 31,
none 1843,
opera 69,
politics 9,
private 15,
quotes 1,
reformat hard drive 19,
sgopc 1,
site update 15,
site version 205,
sleep 3,
star wars 2,
story 4,
swtor 1,
texas 1,
video 5,
website 22,
windows 10 1,
wishlist 3