mysql - There's something weird about my sql query -



mysql - There's something weird about my sql query -

i have table named kategori :

_id | nama 1 | percakapan umum 2 | angka

and seek select simple query this

select * kategori nama = 'angka'

and returns 0 rows shown message

0 rows returned from: select * kategori nama = 'angka'; (took 4ms)

all want show sec record query. doing wrong?

you have space @ start of value.

change:

select * kategori nama = ' angka'

to

select * kategori nama = 'angka'

leading spaces matter, trailing ones not.

see demo

mysql sql database ddms

Comments

Post a Comment

Popular posts from this blog

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

php - Working with pretty urls on apache and fastcgi after hhvm installation -

php - Working with pretty urls on apache and fastcgi after hhvm installation - i needed slim php work pretty urls using .htaccess , no problem. rewriteengine on rewritecond %{request_filename} !-f rewriterule ^ index.php [qsa,l] now ran using hhvm, fastcgi using virtual host config. <virtualhost *:80> servername project.dev serveralias www.project.dev documentroot /var/www/project proxypassmatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/var/www/project/$1 <directory "/var/www/project"> allowoverride order allow,deny allow </directory> </virtualhost> of course, won't read .htaccess file, thought of adding .htaccess config in virtual host config, no, won't work. like so: <virtualhost *:80> servername project.dev serveralias www.project.dev documentroot /var/www/project proxypassmatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/var/www/project/$1 <directory "/var/www/project"...
Read more